mysql text 长度
http://justdo2008.iteye.com/blog/576552
mysql的text类型有64K长度限制的,MEDIUMTEXT中型是2G,LONGTEXT大型是4G .
| 类型 | 最大长度 |
| char | 255 |
| vharchar | 65535 |
| tinyblob tinytext | 255 (2^8-1) |
| BLOB TEXT | 65535 (2^16-1) |
| MEDIUMBLOB MEDIUMTEXT | 16777215 (2^24-1) |
| LONGBLOB LONGTEXT | 4294967295 (2^32-1) |
| tinyint | -128~127 0~255 |
| bit | tinyint(1) |
| bool | tinyint(1) |
| smallint | -32768~32767 0~65535 |
| mediumint | 16777215 |
| int | 2^32-1 |
| integer | 同int |
| bigint | 2^64 |
| float | |
| double | |
| real | 同double |
| decimal | |
| dec | 同decimal |
| numeric | 同decimal |